Binding to a data table

This first code example demonstrates how to create a connection to the Access version of the Northwind database and create a property named "Orders" to which the grid will be bound. The code should be placed in the App.xaml.cs file.

VB.NET	Copy Code
Public Partial Class App Inherits Application Public Property Data As DataSet Public Property Orders As DataTable Protected Overrides Sub OnStartup(ByVal e As StartupEventArgs) ' Set the licence key Xceed.Wpf.DataGrid.Licenser.LicenseKey = "Enter your license key here" Data = Xceed.Wpf.DataGrid.Samples.SampleData.DataProvider.GetNorthwindDataSet() Orders = Data.Tables("Orders") MyBase.OnStartup(e) End Sub End Class

VB.NET

Copy Code

Public Partial Class App

    Inherits Application



    Public Property Data As DataSet

    Public Property Orders As DataTable



    Protected Overrides Sub OnStartup(ByVal e As StartupEventArgs)

        ' Set the licence key

        Xceed.Wpf.DataGrid.Licenser.LicenseKey = "Enter your license key here"

        Data = Xceed.Wpf.DataGrid.Samples.SampleData.DataProvider.GetNorthwindDataSet()

        Orders = Data.Tables("Orders")

        MyBase.OnStartup(e)

    End Sub

End Class

C#	Copy Code
public partial class App : Application { public DataSet Data { get; set; } public DataTable Orders { get; set; } protected override void OnStartup( StartupEventArgs e ) { // Set the licence key Xceed.Wpf.DataGrid.Licenser.LicenseKey = "Enter your license key here"; Data = Xceed.Wpf.DataGrid.Samples.SampleData.DataProvider.GetNorthwindDataSet(); Orders = Data.Tables[ "Orders" ]; base.OnStartup( e ); } }

Copy Code

public partial class App : Application

  {

    public DataSet Data

    {

      get; set;

    }

    public DataTable Orders

    {

      get; set;

    }

    protected override void OnStartup( StartupEventArgs e )

    {

      // Set the licence key

      Xceed.Wpf.DataGrid.Licenser.LicenseKey = "Enter your license key here";

      Data = Xceed.Wpf.DataGrid.Samples.SampleData.DataProvider.GetNorthwindDataSet();

      Orders = Data.Tables[ "Orders" ];

      base.OnStartup( e );

    }

  }

The next example demonstrates how to bind a grid to the Orders table, which is retrieved through the Orders property implemented in the code above.

XAML	Copy Code
<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> <Grid.Resources> <xcdg:DataGridCollectionViewSource x:Key="cvs_orders" Source="{Binding Source={x:Static Application.Current}, Path=Orders}"/> </Grid.Resources> <xcdg:DataGridControl x:Name="OrdersGrid" ItemsSource="{Binding Source={StaticResource cvs_orders}}"/> </Grid>

XAML

Copy Code

<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid">

  <Grid.Resources>      

  <xcdg:DataGridCollectionViewSource x:Key="cvs_orders"

                                  Source="{Binding Source={x:Static Application.Current},

                                                      Path=Orders}"/>

  </Grid.Resources>

  <xcdg:DataGridControl x:Name="OrdersGrid"

                        ItemsSource="{Binding Source={StaticResource cvs_orders}}"/>

</Grid>